USE AdventureWorks2008
GO

DECLARE @Manager hierarchyid 
SELECT @Manager = hierarchyid::GetRoot()
FROM Sales.SalesTerritoryOrg ;

INSERT INTO Sales.SalesTerritoryOrg (OrgNode, TerritoryID, TerritoryName)
VALUES
(@Manager.GetDescendant(NULL, NULL), 2, 'North America') ; 